package com.ciko.code.logic.table;

import android.provider.BaseColumns;



/**
 * 联系人分组信息表
 * @author 刘宾  
 * @date 2015年12月15日 下午2:38:29
 */
public class GroupTable
{
	
	public static final String table = "t_group";
	
	public final class GroupColums
	        implements
	        BaseColumns
	{
		/** 分组编号 */
		public final static String GROUP_ID  = "groupId";
		/** 是否删除 y=是 n=否 */
		public final static String IS_DELETE = "isDelete";
		/** 分组名称 */
		public final static String NAME      = "name";
		/** 分组排序号 */
		public final static String SORT_NUM  = "sortNum";
		
	}
	
	public static String getCreateTableSQL() {
		StringBuilder sb = new StringBuilder();
		sb.append("CREATE TABLE IF NOT EXISTS " + table + "(");
		sb.append(GroupColums.GROUP_ID + " INTEGER,");
		sb.append(GroupColums.IS_DELETE + " VARCHAR(10),");
		sb.append(GroupColums.NAME + " VARCHAR(50),");
		sb.append(GroupColums.SORT_NUM + " INTEGER");
		sb.append(");");
		return sb.toString();
	}
}
